Factory implementation cost |
€300,000 |
|
|
|
|
|
|
|
Production cost of each unit |
€25,000 |
|
|
|
|
|
|
|
Asset value of each machine |
€40,000 |
|
|
|
|
|
|
|
Amount of daily servings per machine |
50 |
|
|
|
|
|
|
|
PVP of each dose |
€1.20 |
|
|
|
|
|
|
|
Each machine is amortized in (days) |
417 |
|
|
|
|
|
|
|
Production start date |
2022-01-01 |
|
|
|
|
|
|
|
Total loan |
€1,094,400 |
* I can receive phased |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Start date of series production, 1 per week |
machine profit |
Number of active machines |
Amount of Money Required |
Profit |
capital |
amortization |
In debt |
Patrimony |
|
2022-01 |
|
|
€400,000 |
|
|
|
€400,000 |
€460,000 |
* Equity is greater than debt. Equal to factory cost + cost of 4 units per month |
2022-02 |
€6 720 |
4 |
€93 280 |
|
|
€5,000 |
€488 280 |
€620,000 |
|
2022-03 |
€13 440 |
8th |
€86 560 |
|
|
€5,000 |
€569,840 |
€780,000 |
|
2022-04 |
€20 160 |
12 |
€79 840 |
|
|
€5,000 |
€644 680 |
€940,000 |
|
2022-05 |
€26,880 |
16 |
€73 120 |
|
|
€5,000 |
€712 800 |
€1,100,000 |
|
2022-06 |
€33,600 |
20 |
€66 400 |
|
|
€5,000 |
€774 200 |
€1,260,000 |
|
2022-07 |
€40 320 |
24 |
€59 680 |
|
|
€5,000 |
€828 880 |
€1,420,000 |
|
2022-08 |
€47 040 |
28 |
€52 960 |
|
|
€5,000 |
€876 840 |
€1,580,000 |
|
2022-09 |
€53,760 |
32 |
€46 240 |
|
|
€5,000 |
€918 080 |
€1,740,000 |
|
2022-10 |
€60 480 |
36 |
€39 520 |
|
|
€5,000 |
€952 600 |
€1,900,000 |
|
2022-11 |
€67 200 |
40 |
€32 800 |
|
|
€5,000 |
€980 400 |
€2,060,000 |
|
2022-12 |
€73,920 |
44 |
€26 080 |
|
|
€5,000 |
€1,001 480 |
€2,220,000 |
|
2023-01 |
€80 640 |
48 |
€19 360 |
|
|
€5,000 |
€1,015,840 |
€2,380,000 |
|
2023-02 |
€87 360 |
52 |
€12 640 |
|
|
€5,000 |
€1,023,480 |
€2,540,000 |
|
2023-03 |
€94 080 |
56 |
€5,920 |
|
|
€5,000 |
€1,024,400 |
€2,700,000 |
|
2023-04 |
€100 800 |
60 |
|
€800 |
|
€5,800 |
€1,018,600 |
€2,860,000 |
|
2023-05 |
€107 520 |
64 |
|
€7 520 |
|
€12 520 |
€1,006,080 |
€3,020,000 |
|
2023-06 |
€114 240 |
68 |
|
€14 240 |
|
€19 240 |
€986 840 |
€3,180,000 |
|
2023-07 |
€120 960 |
72 |
|
€20,960 |
|
€25 960 |
€960 880 |
€3,340,000 |
|
2023-08 |
€127 680 |
76 |
|
€27 680 |
|
€32 680 |
€928 200 |
€3,500,000 |
|
2023-09 |
€134,400 |
80 |
|
€34 400 |
|
€39 400 |
€888 800 |
€3,660,000 |
|
2023-10 |
€141 120 |
84 |
|
€41 120 |
|
€46 120 |
€842 680 |
€3,820,000 |
|
2023-11 |
€147 840 |
88 |
|
€47 840 |
|
€52,840 |
€789 840 |
€3,980,000 |
|
2023-12 |
€154,560 |
92 |
|
€54 560 |
|
€59,560 |
€730 280 |
€4,140,000 |
|
2024-01 |
€161 280 |
96 |
|
€61 280 |
|
€66 280 |
€664,000 |
€4,300,000 |
|
2024-02 |
€168,000 |
100 |
|
€68,000 |
|
€73,000 |
€591,000 |
€4,460,000 |
|
2024-03 |
€174 720 |
104 |
|
€74 720 |
|
€79 720 |
€511 280 |
€4,620,000 |
|
2024-04 |
€181 440 |
108 |
|
€81,440 |
|
€86 440 |
€424 840 |
€4,780,000 |
|
2024-05 |
€188 160 |
112 |
|
€88 160 |
|
€93 160 |
€331 680 |
€4,940,000 |
|
2024-06 |
€194 880 |
116 |
|
€94,880 |
|
€99 880 |
€231 800 |
€5,100,000 |
|
2024-07 |
€201 600 |
120 |
|
€101 600 |
|
€106 600 |
€125 200 |
€5,260,000 |
|
2024-08 |
€208 320 |
124 |
|
€108 320 |
|
€113 320 |
€11,880 |
€5,420,000 |
* Loan gets paid |
2024-09 |
€215 040 |
128 |
|
€115 040 |
€115 040 |
|
|
€5,580,000 |
|
2024-10 |
€221 760 |
132 |
|
€121 760 |
€236 800 |
|
|
€5,740,000 |
|
2024-11 |
€228 480 |
136 |
|
€128 480 |
€365 280 |
|
|
€5,900,000 |
|
2024-12 |
€235 200 |
140 |
|
€135 200 |
€500 480 |
|
|
€6,060,000 |
|
2025-01 |
€241 920 |
144 |
|
€141 920 |
€642 400 |
|
|
€6,220,000 |
|
2025-02 |
€248 640 |
148 |
|
€148 640 |
€791 040 |
|
|
€6,380,000 |
|
2025-03 |
€255 360 |
152 |
|
€155 360 |
€946 400 |
|
|
€6,540,000 |
|
2025-04 |
€262,080 |
156 |
|
€162 080 |
€1,108,480 |
|
|
€6,700,000 |
|
2025-05 |
€268,800 |
160 |
|
€168 800 |
€1,277,280 |
|
|
€6,860,000 |
|
2025-06 |
€275 520 |
164 |
|
€175 520 |
€1,452,800 |
|
|
€7,020,000 |
|
2025-07 |
€282 240 |
168 |
|
€182 240 |
€1,635,040 |
|
|
€7,180,000 |
|
2025-08 |
€288 960 |
172 |
|
€188 960 |
€1,824,000 |
|
|
€7,340,000 |
|
2025-09 |
€295 680 |
176 |
|
€195 680 |
€2,019 680 |
|
|
€7,500,000 |
|
2025-10 |
€302,400 |
180 |
|
€202 400 |
€2,222,080 |
|
|
€7,660,000 |
|
2025-11 |
€309 120 |
184 |
|
€209 120 |
€2,431,200 |
|
|
€7,820,000 |
|
2025-12 |
€315 840 |
188 |
|
€215 840 |
€2,647,040 |
|
|
€7,980,000 |
|
2026-01 |
€322 560 |
192 |
|
€222,560 |
€2,869,600 |
|
|
€8,140,000 |
|
2026-02 |
€329 280 |
196 |
|
€229 280 |
€3,098,880 |
|
|
€8,300,000 |
|
2026-03 |
€336,000 |
200 |
|
€236,000 |
€3,334,880 |
|
|
€8,460,000 |
|
2026-04 |
€342 720 |
204 |
|
€242 720 |
€3,577,600 |
|
|
€8,620,000 |
|
2026-05 |
€349 440 |
208 |
|
€249 440 |
€3,827,040 |
|
|
€8 780 000 |
|
2026-06 |
€356 160 |
212 |
|
€256 160 |
€4,083,200 |
|
|
€8,940,000 |
|
2026-07 |
€362 880 |
216 |
|
€262,880 |
€4,346,080 |
|
|
€9 100,000 |
|
2026-08 |
€369 600 |
220 |
|
€269 600 |
€4,615,680 |
|
|
€9,260,000 |
|
2026-09 |
€376 320 |
224 |
|
€276 320 |
€4,892,000 |
|
|
€9,420,000 |
|
2026-10 |
€383,040 |
228 |
|
€283,040 |
€5,175,040 |
|
|
€9,580,000 |
|
2026-11 |
€389 760 |
232 |
|
€289 760 |
€5,464,800 |
|
|
€9 740 000 |
|
2026-12 |
€396 480 |
236 |
|
€296 480 |
€5,761,280 |
|
|
€9,900,000 |
|
2027-01 |
€403,200 |
240 |
|
€303,200 |
€6,064 480 |
|
|
€10,060,000 |
|
2027-02 |
€409 920 |
244 |
|
€309 920 |
€6 374 400 |
|
|
€10 220,000 |
|
2027-03 |
€416 640 |
248 |
|
€316 640 |
€6,691,040 |
|
|
€10,380,000 |
|
2027-04 |
€423 360 |
252 |
|
€323 360 |
€7,014 400 |
|
|
€10 540 000 |
|
2027-05 |
€430 080 |
256 |
|
€330 080 |
€7 344 480 |
|
|
€10 700 000 |
|
2027-06 |
€436 800 |
260 |
|
€336 800 |
€7,681,280 |
|
|
€10,860,000 |
|
2027-07 |
€443 520 |
264 |
|
€343 520 |
€8,024,800 |
|
|
€11,020,000 |
|
2027-08 |
€450 240 |
268 |
|
€350 240 |
€8 375 040 |
|
|
€11,180,000 |
|
2027-09 |
€456,960 |
272 |
|
€356 960 |
€8 732 000 |
|
|
€11,340,000 |
|